lis = [
['CIN', 'COMPANY NAME', 'DATE OF INCORPORATION', 'STATE', 'ROC', 'CATEGORY', 'SUB CATEGORY', 'CLASS', 'AUTHORIZED_CAPITAL', 'PAID CAPITAL', ],
['CIN', 'COMPANY NAME', 'INC-29', 'DATE OF INCORPORATION', 'STATE', 'ROC', 'CATEGORY', 'SUB CATEGORY', 'CLASS', 'AUTHORIZED_CAPITAL', 'PAID CAPITAL', 'NUMBER OF MEMBERS (Applicable only in case of Co. without share Capital)', 'ACTIVITY_DESCRIPTION', 'REGISTERED_OFFICE_ADDRESS'],
['CIN', 'COMPANY NAME', 'DATE OF REGISTRATION', 'MONTH NAME', 'STATE', 'ROC', 'CLASS', 'COMPANY STATUS', 'COMPANY TYPE', 'CATEGORY', 'ACTIVITY CODE', 'ACTIVITY DESCRIPTION', 'REGISTERED OFFICE ADDRESS'],
['CIN', 'COMPANY NAME', 'DATE OF REGISTRATION', 'MONTH NAME', 'STATE', 'ROC', 'TYPE OF OFFICE', 'COMPANY STATUS', 'ACTIVITY CODE', 'ACTIVITY DESCRIPTION', 'REGISTERED OFFICE ADDRESS'],
['CIN', 'COMPANY NAME', 'DATE OF REGISTRATION', 'MONTH NAME', 'STATE', 'ROC', 'TYPE OF OFFICE', 'COMPANY STATUS', 'ACTIVITY CODE', 'ACTIVITY DESCRIPTION', 'REGISTERED OFFICE ADDRESS', 'EMAIL'],
['CIN', 'COMPANY NAME', 'DATE OF REGISTRATION', 'MONTH NAME', 'STATE', 'ROC', 'CLASS', 'COMPANY STATUS', 'COMPANY TYPE', 'CATEGORY', 'AUTHORIZED CAPITAL', 'PAIDUP CAPITAL', 'ACTIVITY CODE', 'ACTIVITY DESCRIPTION', 'REGISTERED OFFICE ADDRESS'],
['CIN', 'COMPANY NAME', 'DATE OF REGISTRATION', 'MONTH NAME', 'STATE', 'ROC', 'COMPANY STATUS', 'CATEGORY', 'CLASS', 'COMPANY TYPE', 'AUTHORIZED CAPITAL', 'PAIDUP CAPITAL', 'ACTIVITY CODE', 'ACTIVITY DESCRIPTION', 'REGISTERED OFFICE ADDRESS'],
['CIN', 'COMPANY NAME', 'DATE OF REGISTRATION', 'MONTH NAME', 'STATE', 'ROC', 'COMPANY STATUS', 'Company Category', 'CLASS', 'Company Type', 'AUTHORIZED CAPITAL', 'PAIDUP CAPITAL', 'ACTIVITY CODE', 'ACTIVITY DESCRIPTION', 'REGISTERED OFFICE ADDRESS', 'EMAIL'],
['CIN', 'COMPANY NAME', 'DATE OF REGISTRATION', 'MONTH NAME', 'STATE', 'ROC', 'COMPANY STATUS', 'CATEGORY', 'CLASS', 'COMPANY TYPE', 'AUTHORIZED CAPITAL', 'PAIDUP CAPITAL', 'ACTIVITY CODE', 'ACTIVITY DESCRIPTION', 'REGISTERED OFFICE ADDRESS', 'EMAIL'],
['CIN', 'COMPANY NAME', 'DATE OF REGISTRATION', 'MONTH NAME', 'STATE', 'ROC', 'COMPANY STATUS', 'CATEGORY', 'CLASS', 'COMPANY TYPE', 'Paid-up Capital (In Thousand Rs.)', 'Authorized Capital (In Thousand Rs.)', 'ACTIVITY CODE', 'ACTIVITY DESCRIPTION', 'REGISTERED OFFICE ADDRESS', 'EMAIL'],
['CIN', 'COMPANY_NAME', 'DATE_OF_REGISTRATION', 'MONTH_NAME', 'STATE', 'ROC', 'CLASS', 'COMPANY_STATUS', 'COMPANY_TYPE', 'CATEGORY', 'AUTHORIZED_CAPITAL', 'PAIDUP_CAPITAL', 'ACTIVITY_CODE', 'ACTIVITY_DESCRIPTION', 'REGISTERED_OFFICE_ADDRESS'],
['CIN', 'COMPANY_NAME', 'DATE_OF_REGISTRATION', 'MONTH_NAME', 'STATE', 'ROC', 'TYPE OF OFFICE', 'COMPANY_STATUS', 'TYPE', 'ACTIVITY_CODE', 'ACTIVITY_DESCRIPTION', 'REGISTERED_OFFICE_ADDRESS'],
['CIN', 'Company Name', 'Date of Registration', 'Month Name', 'State ', 'ROC', 'Company Status', 'Company Category', 'Company Class', 'Nature of Company', 'Authorized Capital (In Thousand Rs.)', 'Paid-up Capital (In Thousand Rs.)', 'Industrial Activity Code', 'ACTIVITY DESCRIPTION', 'Company Address', 'Company Email ID'],
['ROC Location', 'CIN', 'Company Name', 'Date of Registration', 'MONTH NAME', 'Company Class', 'Listed Flag', 'Company Category', 'Company Sub-category', 'Company Status', 'Nature of Company', 'Industrial Activity Code', 'Industrial Description', 'State ', ' Address', 'Company Email ID', 'Paid-up Capital (In Thousand Rs.)', 'Authorized Capital (In Thousand Rs.)'],
['ROC Location', 'CIN', 'Company Name', 'Date of Registration', 'MONTH NAME', 'Company Class', 'Listed Flag', 'Company Category', 'Company Sub-category', 'Company Status', 'Nature of Company', 'Industrial Activity Code', 'State ', 'Company Address', 'Company Email ID', 'Paid-up Capital (In Thousand Rs.)', 'Authorized Capital (In Thousand Rs.)'],
['FCIN', 'COMPANY NAME', 'DATE OF REGISTRATION', 'MONTH NAME', 'STATE', 'ROC', 'TYPE OF OFFICE', 'COMPANY STATUS',
 'ACTIVITY CODE', 'ACTIVITY DESCRIPTION', 'REGISTERED OFFICE ADDRESS', 'EMAIL'],
['FCIN', 'Company Name', 'Date', 'Status', 'Activity', 'Description', 'Office Type', 'Address', 'Email', 'State'],
['FCRN', 'COMPANY NAME', 'DATE OF REGISTRATION', 'COUNTRY OF INCORPORATION', 'STATE', 'ROC', 'TYPE OF OFFICE', 'ACTIVITY DESCRIPTION', 'FOREIGN OFFICE ADDRESS', 'FOREIGN COMPANY PRESENT ADDRESS IN INDIA']
]
pins = [['LLPIN', 'LLP Name', 'Founded', 'RoC', 'Status', 'Industrial Activity', 'Description', 'Obligation of Contribution(Rs.)', 'Number of Designated Partners', 'Number of Partners', 'State', 'District', 'Address', 'Email'],
['LLPIN', 'LIMITED LIABILITY PARTNERSHIP NAME', 'DATE OF INCORPORATION', 'STATE', 'ROC', 'NUMBER OF PARTNERS', 'NUMBER OF DESIGNATED PARTNERS', 'TOTAL OBLIGATION OF CONTRIBUTION', 'ACTIVITY CODE', 'ACTIVITY DESCRIPTION', 'REGISTERED_OFFICE_ADDRESS'],
['LLPIN', 'LIMITED LIABILITY PARTNERSHIP NAME', 'DATE OF INCORPORATION', 'STATE', 'ROC', 'NUMBER OF PARTNERS', 'NUMBER OF DESIGNATED PARTNERS', 'TOTAL OBLIGATION OF CONTRIBUTION', 'ACTIVITY CODE', 'ACTIVITY DESCRIPTION', 'REGISTERED OFFICE ADDRESS', 'Email'],
['LLPIN', 'LIMITED LIABILITY PARTNERSHIP NAME', 'DATE OF INCORPORATION', 'STATE', 'ROC', 'NUMBER OF PARTNERS', 'NUMBER OF DESIGNATED PARTNERS', 'TOTAL OBLIGATION OF CONTRIBUTION', 'ACTIVITY DESCRIPTION', 'REGISTERED_OFFICE_ADDRESS'],
['ROC Location', 'Date of Incorporation', 'LLPIN', 'LLP Name', 'MONTH NAME', 'LLP Status', 'Industrial Activity Code', 'Industrial Activity description', 'Obligation of Contribution(Rs.)', 'Number of Designated Partners', 'Number of Partners', 'State', 'District', 'Address', 'Email'],
['ROC Location', 'Date of Incorporation', 'LLPIN', 'LLP Name', 'LLP Status', 'Industrial Activity Code', 'Industrial Activity', 'Obligation of Contribution(Rs.)', 'Number of Designated Partners', 'Number of Partners', 'State', 'District', 'Address', 'Email'],
['ROC Location', 'Date of Incorporation', 'MONTH NAME', 'LLPIN', 'LLP Name', 'LLP Status', 'Industrial Activity Code', 'Industrial Activity', 'Obligation of Contribution(Rs.)', 'Number of Designated Partners', 'Number of Partners', 'State', 'Address', 'Email']]

template = []
for li in pins:
    for i in li:
        if i.lower().strip().replace(' ','_') not in template:
            template.append(i.strip().lower().replace(' ','_'))

print(template)
print(len(template))


# llpin
# llp_name
# founded
# roc / roc_location
# llp_status /  status
# month_name
# date_of_incorporation
# industrial_activity
# activity_description /description / industrial_activity_description
# obligation_of_contribution(rs.)
# number_of_designated_partners
# state
# activity_code / industrial_activity_code
# number_of_partners # 合作伙伴数量
# district
# address / registered_office_address
# email
# limited_liability_partnership_name　# 有限责任合伙企业名称
# total_obligation_of_contribution # 出资义务总额




# cin / fcin / fcrn
# company_name
# month_name
# date_of_incorporation / date_of_registration / date
# state
# roc / roc_location
# category / company_category
# sub_category / company_sub-category
# nature_of_company
# class / company_class
# authorized_capital /
# authorized_capital_(in_thousand_rs.)
# paid_capital / paidup_capital
# paid-up_capital_(in_thousand_rs.)
# inc-29
# number_of_members_(applicable_only_in_case_of_co._without_share_capital)
# activity_description / industrial_description / description
# registered_office_address / address / company_address / foreign_company_present_address_in_india
# country_of_incorporation
# foreign_office_address
# company_type / type
# company_status / status
# activity_code / industrial_activity_code
# type_of_office / office_type
# listed_flag
# email / company_email_id

# print(template)
# print(len(template))
temp = ['cin', 'company_name', 'date_of_incorporation', 'state', 'roc', 'category', 'sub_category', 'class', 'authorized_capital', 'paid_capital', 'inc-29', 'number_of_members_(applicable_only_in_case_of_co._without_share_capital)', 'activity_description', 'registered_office_address', 'date_of_registration', 'month_name', 'company_status', 'company_type', 'activity_code', 'type_of_office', 'email', 'paidup_capital', 'company_category', 'paid-up_capital_(in_thousand_rs.)', 'authorized_capital_(in_thousand_rs.)', 'type', 'company_class', 'nature_of_company', 'industrial_activity_code', 'company_address', 'company_email_id', 'roc_location', 'listed_flag', 'company_sub-category', 'industrial_description', 'address','fcin', 'status', 'activity', 'description', 'office_type', 'fcrn', 'country_of_incorporation', 'foreign_office_address', 'foreign_company_present_address_in_india']

tmp_li = ['ROC Location', 'CIN', 'Company Name', 'Date of Registration', 'MONTH NAME', 'Company Class', 'Listed Flag', 'Company Category', 'Company Sub-category', 'Company Status', 'Nature of Company', 'Industrial Activity Code', 'State ', 'Company Address', 'Company Email ID', 'Paid-up Capital (In Thousand Rs.)', 'Authorized Capital (In Thousand Rs.)'],






